Pandas Profiling Report

Dataset statistics

Number of variables	47
Number of observations	60398
Missing cells	1
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	21.7 MiB
Average record size in memory	376.0 B

Variable types

Numeric	18
Categorical	21
Text	3
DateTime	5

Alerts

`RevisionNumber` has constant value ""	Constant
`OrderQuantity` has constant value ""	Constant
`Age` is highly overall correlated with `Age Range` and 1 other fields	High correlation
`Age Range` is highly overall correlated with `Age`	High correlation
`Cost` is highly overall correlated with `DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName` and 9 other fields	High correlation
`CurrencyKey` is highly overall correlated with `DimCurrency.CurrencyName` and 4 other fields	High correlation
`DimCurrency.CurrencyName` is highly overall correlated with `CurrencyKey` and 3 other fields	High correlation
`DimCustomer.EnglishOccupation` is highly overall correlated with `YearlyIncomeRange`	High correlation
`DimCustomer.TotalChildren` is highly overall correlated with `Age`	High correlation
`DimCustomer.YearlyIncome` is highly overall correlated with `YearlyIncomeRange`	High correlation
`DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName` is highly overall correlated with `Cost` and 9 other fields	High correlation
`DimProduct.DimProductSubcategory.EnglishProductSubcategoryName` is highly overall correlated with `DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName` and 1 other fields	High correlation
`DimProduct.ProductSubcategoryKey` is highly overall correlated with `Cost` and 9 other fields	High correlation
`DimPromotion.EnglishPromotionCategory` is highly overall correlated with `DimPromotion.EnglishPromotionName` and 2 other fields	High correlation
`DimPromotion.EnglishPromotionName` is highly overall correlated with `DimPromotion.EnglishPromotionCategory` and 2 other fields	High correlation
`DimPromotion.EnglishPromotionType` is highly overall correlated with `DimPromotion.EnglishPromotionCategory` and 2 other fields	High correlation
`DimSalesTerritory.SalesTerritoryCountry` is highly overall correlated with `CurrencyKey` and 4 other fields	High correlation
`DimSalesTerritory.SalesTerritoryGroup` is highly overall correlated with `CurrencyKey` and 3 other fields	High correlation
`DimSalesTerritory.SalesTerritoryRegion` is highly overall correlated with `CurrencyKey` and 3 other fields	High correlation
`ExtendedAmount` is highly overall correlated with `Cost` and 9 other fields	High correlation
`Freight` is highly overall correlated with `Cost` and 9 other fields	High correlation
`ProductKey` is highly overall correlated with `DimProduct.DimProductSubcategory.EnglishProductSubcategoryName`	High correlation
`ProductStandardCost` is highly overall correlated with `Cost` and 9 other fields	High correlation
`Profit` is highly overall correlated with `Cost` and 8 other fields	High correlation
`PromotionKey` is highly overall correlated with `DimPromotion.EnglishPromotionCategory` and 2 other fields	High correlation
`SalesAmount` is highly overall correlated with `Cost` and 9 other fields	High correlation
`SalesTerritoryKey` is highly overall correlated with `CurrencyKey` and 1 other fields	High correlation
`TaxAmt` is highly overall correlated with `Cost` and 9 other fields	High correlation
`TotalProductCost` is highly overall correlated with `Cost` and 9 other fields	High correlation
`UnitPrice` is highly overall correlated with `Cost` and 9 other fields	High correlation
`YearlyIncomeRange` is highly overall correlated with `DimCustomer.EnglishOccupation` and 1 other fields	High correlation
`PromotionKey` is highly imbalanced (88.7%)	Imbalance
`DimPromotion.EnglishPromotionName` is highly imbalanced (88.7%)	Imbalance
`DimPromotion.EnglishPromotionType` is highly imbalanced (85.7%)	Imbalance
`DimPromotion.EnglishPromotionCategory` is highly imbalanced (77.8%)	Imbalance
`DimCustomer.TotalChildren` has 17048 (28.2%) zeros	Zeros

Reproduction

Analysis started	2024-04-07 17:14:08.762962
Analysis finished	2024-04-07 17:16:38.715919
Duration	2 minutes and 29.95 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

ProductKey
Real number (ℝ)

HIGH CORRELATION

Distinct	158
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	437.55793

Minimum	214
Maximum	606
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	214
5-th percentile	217
Q1	359
median	479
Q3	529
95-th percentile	581
Maximum	606
Range	392
Interquartile range (IQR)	170

Descriptive statistics

Standard deviation	118.08839
Coefficient of variation (CV)	0.26988058
Kurtosis	-0.67398995
Mean	437.55793
Median Absolute Deviation (MAD)	58
Skewness	-0.79879556
Sum	26427624
Variance	13944.868
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
477	4244	7.0%
480	3191	5.3%
528	3095	5.1%
529	2376	3.9%
214	2230	3.7%
225	2190	3.6%
222	2125	3.5%
485	2121	3.5%
217	2085	3.5%
478	2025	3.4%
Other values (148)	34716	57.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
214	2230	3.7%
217	2085	3.5%
222	2125	3.5%
225	2190	3.6%
228	429	0.7%
231	442	0.7%
234	452	0.7%
237	413	0.7%
310	336	0.6%
311	281	0.5%

Value	Count	Frequency (%)
606	386	0.6%
605	363	0.6%
604	360	0.6%
600	41	0.1%
599	56	0.1%
598	58	0.1%
597	49	0.1%
596	48	0.1%
595	48	0.1%
594	50	0.1%

CustomerKey
Real number (ℝ)

Distinct	18484
Distinct (%)	30.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18841.685

Minimum	11000
Maximum	29483
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	11000
5-th percentile	11414
Q1	14003
median	18143
Q3	23429.75
95-th percentile	28108.15
Maximum	29483
Range	18483
Interquartile range (IQR)	9426.75

Descriptive statistics

Standard deviation	5432.4304
Coefficient of variation (CV)	0.28831977
Kurtosis	-1.1617483
Mean	18841.685
Median Absolute Deviation (MAD)	4594.5
Skewness	0.28365312
Sum	1.1380001 × 10⁹
Variance	29511300
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11185	68	0.1%
11300	67	0.1%
11277	65	0.1%
11262	63	0.1%
11287	62	0.1%
11176	60	0.1%
11091	59	0.1%
11331	58	0.1%
11566	58	0.1%
11330	57	0.1%
Other values (18474)	59781	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11000	8	< 0.1%
11001	11	< 0.1%
11002	4	< 0.1%
11003	9	< 0.1%
11004	6	< 0.1%
11005	6	< 0.1%
11006	5	< 0.1%
11007	8	< 0.1%
11008	7	< 0.1%
11009	5	< 0.1%

Value	Count	Frequency (%)
29483	1	< 0.1%
29482	1	< 0.1%
29481	1	< 0.1%
29480	5	< 0.1%
29479	1	< 0.1%
29478	3	< 0.1%
29477	3	< 0.1%
29476	1	< 0.1%
29475	1	< 0.1%
29474	1	< 0.1%

PromotionKey
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

1	58247
2	2118
13	20
14	13

Length

Max length	2
Median length	1
Mean length	1.0005464
Min length	1

Characters and Unicode

Total characters	60431
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	58247	96.4%
2	2118	3.5%
13	20	< 0.1%
14	13	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	58247	96.4%
2	2118	3.5%
13	20	< 0.1%
14	13	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	58280	96.4%
2	2118	3.5%
3	20	< 0.1%
4	13	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60431	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	58280	96.4%
2	2118	3.5%
3	20	< 0.1%
4	13	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60431	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	58280	96.4%
2	2118	3.5%
3	20	< 0.1%
4	13	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60431	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	58280	96.4%
2	2118	3.5%
3	20	< 0.1%
4	13	< 0.1%

CurrencyKey
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.845326

Minimum	6
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	6
5-th percentile	6
Q1	19
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	94
Interquartile range (IQR)	81

Descriptive statistics

Standard deviation	42.146363
Coefficient of variation (CV)	0.60342425
Kurtosis	-1.4488281
Mean	69.845326
Median Absolute Deviation (MAD)	0
Skewness	-0.72070268
Sum	4218518
Variance	1776.3159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
100	33400	55.3%
6	12988	21.5%
19	7135	11.8%
98	6740	11.2%
29	76	0.1%
39	59	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	12988	21.5%
19	7135	11.8%
29	76	0.1%
39	59	0.1%
98	6740	11.2%
100	33400	55.3%

Value	Count	Frequency (%)
100	33400	55.3%
98	6740	11.2%
39	59	0.1%
29	76	0.1%
19	7135	11.8%
6	12988	21.5%

SalesTerritoryKey
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2444617

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	9
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.9611497
Coefficient of variation (CV)	0.47420416
Kurtosis	-0.99206078
Mean	6.2444617
Median Absolute Deviation (MAD)	2
Skewness	-0.48527069
Sum	377153
Variance	8.7684077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	13345	22.1%
4	12265	20.3%
1	8993	14.9%
6	7620	12.6%
10	6906	11.4%
8	5625	9.3%
7	5558	9.2%
5	39	0.1%
2	27	< 0.1%
3	20	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8993	14.9%
2	27	< 0.1%
3	20	< 0.1%
4	12265	20.3%
5	39	0.1%
6	7620	12.6%
7	5558	9.2%
8	5625	9.3%
9	13345	22.1%
10	6906	11.4%

Value	Count	Frequency (%)
10	6906	11.4%
9	13345	22.1%
8	5625	9.3%
7	5558	9.2%
6	7620	12.6%
5	39	0.1%
4	12265	20.3%
3	20	< 0.1%
2	27	< 0.1%
1	8993	14.9%

SalesOrderNumber
Text

Distinct	27659
Distinct (%)	45.8%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	422786
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9668 ?
Unique (%)	16.0%

Sample

1st row	SO43700
2nd row	SO43719
3rd row	SO43726
4th row	SO43762
5th row	SO43771

Value	Count	Frequency (%)
so72656	8	< 0.1%
so58845	8	< 0.1%
so70714	8	< 0.1%
so58572	7	< 0.1%
so74869	7	< 0.1%
so71961	7	< 0.1%
so51555	7	< 0.1%
so61412	7	< 0.1%
so54784	7	< 0.1%
so64542	7	< 0.1%
Other values (27649)	60325	99.9%

Most occurring characters

Value	Count	Frequency (%)
S	60398	14.3%
O	60398	14.3%
6	47143	11.2%
5	44004	10.4%
7	35344	8.4%
4	30836	7.3%
2	25066	5.9%
3	24928	5.9%
1	23946	5.7%
0	23824	5.6%
Other values (2)	46899	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	422786	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	60398	14.3%
O	60398	14.3%
6	47143	11.2%
5	44004	10.4%
7	35344	8.4%
4	30836	7.3%
2	25066	5.9%
3	24928	5.9%
1	23946	5.7%
0	23824	5.6%
Other values (2)	46899	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	422786	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	60398	14.3%
O	60398	14.3%
6	47143	11.2%
5	44004	10.4%
7	35344	8.4%
4	30836	7.3%
2	25066	5.9%
3	24928	5.9%
1	23946	5.7%
0	23824	5.6%
Other values (2)	46899	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	422786	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	60398	14.3%
O	60398	14.3%
6	47143	11.2%
5	44004	10.4%
7	35344	8.4%
4	30836	7.3%
2	25066	5.9%
3	24928	5.9%
1	23946	5.7%
0	23824	5.6%
Other values (2)	46899	11.1%

SalesOrderLineNumber
Real number (ℝ)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8863207

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0163284
Coefficient of variation (CV)	0.53878876
Kurtosis	0.69706876
Mean	1.8863207
Median Absolute Deviation (MAD)	1
Skewness	1.0693116
Sum	113930
Variance	1.0329235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	27659	45.8%
2	17991	29.8%
3	9828	16.3%
4	3958	6.6%
5	820	1.4%
6	124	0.2%
7	15	< 0.1%
8	3	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	27659	45.8%
2	17991	29.8%
3	9828	16.3%
4	3958	6.6%
5	820	1.4%
6	124	0.2%
7	15	< 0.1%
8	3	< 0.1%

Value	Count	Frequency (%)
8	3	< 0.1%
7	15	< 0.1%
6	124	0.2%
5	820	1.4%
4	3958	6.6%
3	9828	16.3%
2	17991	29.8%
1	27659	45.8%

RevisionNumber
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

1	60398

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	60398	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

OrderQuantity
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

1	60398

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	60398	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	60398	100.0%

UnitPrice
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	486.08691

Minimum	2.29
Maximum	3578.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	2.29
5-th percentile	2.29
Q1	7.95
median	29.99
Q3	539.99
95-th percentile	2443.35
Maximum	3578.27
Range	3575.98
Interquartile range (IQR)	532.04

Descriptive statistics

Standard deviation	928.48989
Coefficient of variation (CV)	1.9101314
Kurtosis	2.5136486
Mean	486.08691
Median Absolute Deviation (MAD)	25
Skewness	1.9275149
Sum	29358677
Variance	862093.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
4.99	8827	14.6%
34.99	6440	10.7%
8.99	4470	7.4%
2.29	3191	5.3%
3.99	2376	3.9%
21.98	2121	3.5%
9.99	2025	3.4%
24.99	1788	3.0%
49.99	1736	2.9%
539.99	1695	2.8%
Other values (32)	25729	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.29	3191	5.3%
3.99	2376	3.9%
4.99	8827	14.6%
7.95	908	1.5%
8.99	4470	7.4%
9.99	2025	3.4%
21.49	1044	1.7%
21.98	2121	3.5%
24.49	1430	2.4%
24.99	1788	3.0%

Value	Count	Frequency (%)
3578.27	1551	2.6%
3399.99	185	0.3%
3374.99	211	0.3%
2443.35	1145	1.9%
2384.07	1255	2.1%
2319.99	1215	2.0%
2294.99	1262	2.1%
2181.5625	758	1.3%
2071.4196	521	0.9%
2049.0982	554	0.9%

ExtendedAmount
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	486.08691

Minimum	2.29
Maximum	3578.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	2.29
5-th percentile	2.29
Q1	7.95
median	29.99
Q3	539.99
95-th percentile	2443.35
Maximum	3578.27
Range	3575.98
Interquartile range (IQR)	532.04

Descriptive statistics

Standard deviation	928.48989
Coefficient of variation (CV)	1.9101314
Kurtosis	2.5136486
Mean	486.08691
Median Absolute Deviation (MAD)	25
Skewness	1.9275149
Sum	29358677
Variance	862093.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
4.99	8827	14.6%
34.99	6440	10.7%
8.99	4470	7.4%
2.29	3191	5.3%
3.99	2376	3.9%
21.98	2121	3.5%
9.99	2025	3.4%
24.99	1788	3.0%
49.99	1736	2.9%
539.99	1695	2.8%
Other values (32)	25729	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.29	3191	5.3%
3.99	2376	3.9%
4.99	8827	14.6%
7.95	908	1.5%
8.99	4470	7.4%
9.99	2025	3.4%
21.49	1044	1.7%
21.98	2121	3.5%
24.49	1430	2.4%
24.99	1788	3.0%

Value	Count	Frequency (%)
3578.27	1551	2.6%
3399.99	185	0.3%
3374.99	211	0.3%
2443.35	1145	1.9%
2384.07	1255	2.1%
2319.99	1215	2.0%
2294.99	1262	2.1%
2181.5625	758	1.3%
2071.4196	521	0.9%
2049.0982	554	0.9%

ProductStandardCost
Real number (ℝ)

HIGH CORRELATION

Distinct	45
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	286.06566

Minimum	0.8565
Maximum	2171.2942
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	0.8565
5-th percentile	0.8565
Q1	2.9733
median	11.2163
Q3	294.5797
95-th percentile	1518.7864
Maximum	2171.2942
Range	2170.4377
Interquartile range (IQR)	291.6064

Descriptive statistics

Standard deviation	552.45764
Coefficient of variation (CV)	1.9312267
Kurtosis	2.6883605
Mean	286.06566
Median Absolute Deviation (MAD)	9.35
Skewness	1.9505468
Sum	17277794
Variance	305209.44
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1.8663	8827	14.6%
13.0863	6440	10.7%
0.8565	3191	5.3%
1.4923	2376	3.9%
3.3623	2280	3.8%
6.9223	2190	3.6%
8.2205	2121	3.5%
3.7363	2025	3.4%
9.3463	1788	3.0%
38.4923	1736	2.9%
Other values (35)	27424	45.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.8565	3191	5.3%
1.4923	2376	3.9%
1.8663	8827	14.6%
2.9733	908	1.5%
3.3623	2280	3.8%
3.7363	2025	3.4%
6.9223	2190	3.6%
8.0373	1044	1.7%
8.2205	2121	3.5%
9.1593	1430	2.4%

Value	Count	Frequency (%)
2171.2942	1551	2.6%
1912.1544	185	0.3%
1898.0944	211	0.3%
1554.9479	706	1.2%
1518.7864	439	0.7%
1481.9379	1255	2.1%
1320.6838	758	1.3%
1265.6195	1215	2.0%
1251.9813	1262	2.1%
1117.8559	521	0.9%

TotalProductCost
Real number (ℝ)

HIGH CORRELATION

Distinct	45
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	286.06566

Minimum	0.8565
Maximum	2171.2942
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	0.8565
5-th percentile	0.8565
Q1	2.9733
median	11.2163
Q3	294.5797
95-th percentile	1518.7864
Maximum	2171.2942
Range	2170.4377
Interquartile range (IQR)	291.6064

Descriptive statistics

Standard deviation	552.45764
Coefficient of variation (CV)	1.9312267
Kurtosis	2.6883605
Mean	286.06566
Median Absolute Deviation (MAD)	9.35
Skewness	1.9505468
Sum	17277794
Variance	305209.44
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1.8663	8827	14.6%
13.0863	6440	10.7%
0.8565	3191	5.3%
1.4923	2376	3.9%
3.3623	2280	3.8%
6.9223	2190	3.6%
8.2205	2121	3.5%
3.7363	2025	3.4%
9.3463	1788	3.0%
38.4923	1736	2.9%
Other values (35)	27424	45.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.8565	3191	5.3%
1.4923	2376	3.9%
1.8663	8827	14.6%
2.9733	908	1.5%
3.3623	2280	3.8%
3.7363	2025	3.4%
6.9223	2190	3.6%
8.0373	1044	1.7%
8.2205	2121	3.5%
9.1593	1430	2.4%

Value	Count	Frequency (%)
2171.2942	1551	2.6%
1912.1544	185	0.3%
1898.0944	211	0.3%
1554.9479	706	1.2%
1518.7864	439	0.7%
1481.9379	1255	2.1%
1320.6838	758	1.3%
1265.6195	1215	2.0%
1251.9813	1262	2.1%
1117.8559	521	0.9%

SalesAmount
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	486.08691

Minimum	2.29
Maximum	3578.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	2.29
5-th percentile	2.29
Q1	7.95
median	29.99
Q3	539.99
95-th percentile	2443.35
Maximum	3578.27
Range	3575.98
Interquartile range (IQR)	532.04

Descriptive statistics

Standard deviation	928.48989
Coefficient of variation (CV)	1.9101314
Kurtosis	2.5136486
Mean	486.08691
Median Absolute Deviation (MAD)	25
Skewness	1.9275149
Sum	29358677
Variance	862093.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
4.99	8827	14.6%
34.99	6440	10.7%
8.99	4470	7.4%
2.29	3191	5.3%
3.99	2376	3.9%
21.98	2121	3.5%
9.99	2025	3.4%
24.99	1788	3.0%
49.99	1736	2.9%
539.99	1695	2.8%
Other values (32)	25729	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.29	3191	5.3%
3.99	2376	3.9%
4.99	8827	14.6%
7.95	908	1.5%
8.99	4470	7.4%
9.99	2025	3.4%
21.49	1044	1.7%
21.98	2121	3.5%
24.49	1430	2.4%
24.99	1788	3.0%

Value	Count	Frequency (%)
3578.27	1551	2.6%
3399.99	185	0.3%
3374.99	211	0.3%
2443.35	1145	1.9%
2384.07	1255	2.1%
2319.99	1215	2.0%
2294.99	1262	2.1%
2181.5625	758	1.3%
2071.4196	521	0.9%
2049.0982	554	0.9%

TaxAmt
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.886954

Minimum	0.1832
Maximum	286.2616
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	0.1832
5-th percentile	0.1832
Q1	0.636
median	2.3992
Q3	43.1992
95-th percentile	195.468
Maximum	286.2616
Range	286.0784
Interquartile range (IQR)	42.5632

Descriptive statistics

Standard deviation	74.279193
Coefficient of variation (CV)	1.9101314
Kurtosis	2.5136484
Mean	38.886954
Median Absolute Deviation (MAD)	2
Skewness	1.9275149
Sum	2348694.2
Variance	5517.3984
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0.3992	8827	14.6%
2.7992	6440	10.7%
0.7192	4470	7.4%
0.1832	3191	5.3%
0.3192	2376	3.9%
1.7584	2121	3.5%
0.7992	2025	3.4%
1.9992	1788	3.0%
3.9992	1736	2.9%
43.1992	1695	2.8%
Other values (32)	25729	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1832	3191	5.3%
0.3192	2376	3.9%
0.3992	8827	14.6%
0.636	908	1.5%
0.7192	4470	7.4%
0.7992	2025	3.4%
1.7192	1044	1.7%
1.7584	2121	3.5%
1.9592	1430	2.4%
1.9992	1788	3.0%

Value	Count	Frequency (%)
286.2616	1551	2.6%
271.9992	185	0.3%
269.9992	211	0.3%
195.468	1145	1.9%
190.7256	1255	2.1%
185.5992	1215	2.0%
183.5992	1262	2.1%
174.525	758	1.3%
165.7136	521	0.9%
163.9279	554	0.9%

Freight
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.152217

Minimum	0.0573
Maximum	89.4568
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	0.0573
5-th percentile	0.0573
Q1	0.1988
median	0.7498
Q3	13.4998
95-th percentile	61.0838
Maximum	89.4568
Range	89.3995
Interquartile range (IQR)	13.301

Descriptive statistics

Standard deviation	23.212248
Coefficient of variation (CV)	1.9101245
Kurtosis	2.5136492
Mean	12.152217
Median Absolute Deviation (MAD)	0.625
Skewness	1.927515
Sum	733969.61
Variance	538.80847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0.1248	8827	14.6%
0.8748	6440	10.7%
0.2248	4470	7.4%
0.0573	3191	5.3%
0.0998	2376	3.9%
0.5495	2121	3.5%
0.2498	2025	3.4%
0.6248	1788	3.0%
1.2498	1736	2.9%
13.4998	1695	2.8%
Other values (32)	25729	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0573	3191	5.3%
0.0998	2376	3.9%
0.1248	8827	14.6%
0.1988	908	1.5%
0.2248	4470	7.4%
0.2498	2025	3.4%
0.5373	1044	1.7%
0.5495	2121	3.5%
0.6123	1430	2.4%
0.6248	1788	3.0%

Value	Count	Frequency (%)
89.4568	1551	2.6%
84.9998	185	0.3%
84.3748	211	0.3%
61.0838	1145	1.9%
59.6018	1255	2.1%
57.9998	1215	2.0%
57.3748	1262	2.1%
54.5391	758	1.3%
51.7855	521	0.9%
51.2275	554	0.9%

OrderDate
Date

Distinct	1124
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Minimum	2010-12-29 00:00:00
Maximum	2014-01-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

DueDate
Date

Distinct	1124
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Minimum	2011-01-10 00:00:00
Maximum	2014-02-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ShipDate
Date

Distinct	1124
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Minimum	2011-01-05 00:00:00
Maximum	2014-02-04 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

DimCurrency.CurrencyName
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

US Dollar	33400
Australian Dollar	12988
Canadian Dollar	7135
United Kingdom Pound	6740
Deutsche Mark	76

Length

Max length	20
Median length	9
Mean length	12.664608
Min length	9

Characters and Unicode

Total characters	764917
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US Dollar
2nd row	US Dollar
3rd row	US Dollar
4th row	US Dollar
5th row	US Dollar

Common Values

Value	Count	Frequency (%)
US Dollar	33400	55.3%
Australian Dollar	12988	21.5%
Canadian Dollar	7135	11.8%
United Kingdom Pound	6740	11.2%
Deutsche Mark	76	0.1%
French Franc	59	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dollar	53523	42.0%
us	33400	26.2%
australian	12988	10.2%
canadian	7135	5.6%
united	6740	5.3%
kingdom	6740	5.3%
pound	6740	5.3%
deutsche	76	0.1%
mark	76	0.1%
french	59	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
l	120034	15.7%
a	101039	13.2%
	67138	8.8%
o	67003	8.8%
r	66705	8.7%
D	53599	7.0%
n	47596	6.2%
U	40140	5.2%
i	33603	4.4%
S	33400	4.4%
Other values (16)	134660	17.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	764917	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	120034	15.7%
a	101039	13.2%
	67138	8.8%
o	67003	8.8%
r	66705	8.7%
D	53599	7.0%
n	47596	6.2%
U	40140	5.2%
i	33603	4.4%
S	33400	4.4%
Other values (16)	134660	17.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	764917	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	120034	15.7%
a	101039	13.2%
	67138	8.8%
o	67003	8.8%
r	66705	8.7%
D	53599	7.0%
n	47596	6.2%
U	40140	5.2%
i	33603	4.4%
S	33400	4.4%
Other values (16)	134660	17.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	764917	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	120034	15.7%
a	101039	13.2%
	67138	8.8%
o	67003	8.8%
r	66705	8.7%
D	53599	7.0%
n	47596	6.2%
U	40140	5.2%
i	33603	4.4%
S	33400	4.4%
Other values (16)	134660	17.6%

CustomerFullName
Text

Distinct	34939
Distinct (%)	57.8%
Missing	1
Missing (%)	< 0.1%
Memory size	472.0 KiB

Length

Max length	27
Median length	23
Mean length	14.078183
Min length	7

Characters and Unicode

Total characters	850280
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22715 ?
Unique (%)	37.6%

Sample

1st row	Lucas Hill
2nd row	Kelvin Huang
3rd row	Courtney Carter
4th row	Ashley Washington
5th row	Jeremy Murphy

Value	Count	Frequency (%)
l	4215	2.7%
a	4168	2.7%
m	3785	2.4%
j	3166	2.0%
c	3067	2.0%
e	2303	1.5%
r	2186	1.4%
d	1964	1.3%
s	1585	1.0%
k	1114	0.7%
Other values (1032)	128153	82.3%

Most occurring characters

Value	Count	Frequency (%)
	120803	14.2%
a	82885	9.7%
e	69538	8.2%
n	60164	7.1%
r	53992	6.3%
i	43499	5.1%
o	39828	4.7%
l	36502	4.3%
s	27912	3.3%
t	21626	2.5%
Other values (52)	293531	34.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	850280	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	120803	14.2%
a	82885	9.7%
e	69538	8.2%
n	60164	7.1%
r	53992	6.3%
i	43499	5.1%
o	39828	4.7%
l	36502	4.3%
s	27912	3.3%
t	21626	2.5%
Other values (52)	293531	34.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	850280	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	120803	14.2%
a	82885	9.7%
e	69538	8.2%
n	60164	7.1%
r	53992	6.3%
i	43499	5.1%
o	39828	4.7%
l	36502	4.3%
s	27912	3.3%
t	21626	2.5%
Other values (52)	293531	34.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	850280	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	120803	14.2%
a	82885	9.7%
e	69538	8.2%
n	60164	7.1%
r	53992	6.3%
i	43499	5.1%
o	39828	4.7%
l	36502	4.3%
s	27912	3.3%
t	21626	2.5%
Other values (52)	293531	34.5%

DimCustomer.BirthDate
Date

Distinct	6139
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Minimum	1916-02-10 00:00:00
Maximum	1986-06-25 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

DimCustomer.MaritalStatus
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

M	33273
S	27125

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	33273	55.1%
S	27125	44.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	33273	55.1%
s	27125	44.9%

Most occurring characters

Value	Count	Frequency (%)
M	33273	55.1%
S	27125	44.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	33273	55.1%
S	27125	44.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	33273	55.1%
S	27125	44.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	33273	55.1%
S	27125	44.9%

DimCustomer.Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

M	30381
F	30017

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	F
5th row	F

Common Values

Value	Count	Frequency (%)
M	30381	50.3%
F	30017	49.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	30381	50.3%
f	30017	49.7%

Most occurring characters

Value	Count	Frequency (%)
M	30381	50.3%
F	30017	49.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	30381	50.3%
F	30017	49.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	30381	50.3%
F	30017	49.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	30381	50.3%
F	30017	49.7%

DimCustomer.YearlyIncome
Real number (ℝ)

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59715.057

Minimum	10000
Maximum	170000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	10000
5-th percentile	10000
Q1	30000
median	60000
Q3	80000
95-th percentile	130000
Maximum	170000
Range	160000
Interquartile range (IQR)	50000

Descriptive statistics

Standard deviation	33065.427
Coefficient of variation (CV)	0.55372009
Kurtosis	0.53210281
Mean	59715.057
Median Absolute Deviation (MAD)	20000
Skewness	0.78395658
Sum	3.60667 × 10⁹
Variance	1.0933225 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
60000	9470	15.7%
40000	9181	15.2%
70000	8267	13.7%
30000	6994	11.6%
20000	5128	8.5%
80000	4848	8.0%
10000	3352	5.5%
90000	3143	5.2%
50000	1977	3.3%
100000	1955	3.2%
Other values (6)	6083	10.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000	3352	5.5%
20000	5128	8.5%
30000	6994	11.6%
40000	9181	15.2%
50000	1977	3.3%
60000	9470	15.7%
70000	8267	13.7%
80000	4848	8.0%
90000	3143	5.2%
100000	1955	3.2%

Value	Count	Frequency (%)
170000	476	0.8%
160000	359	0.6%
150000	385	0.6%
130000	1906	3.2%
120000	1242	2.1%
110000	1715	2.8%
100000	1955	3.2%
90000	3143	5.2%
80000	4848	8.0%
70000	8267	13.7%

DimCustomer.TotalChildren
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8507401

Minimum	0
Maximum	5
Zeros	17048
Zeros (%)	28.2%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	3
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6210704
Coefficient of variation (CV)	0.87590387
Kurtosis	-0.97268895
Mean	1.8507401
Median Absolute Deviation (MAD)	1
Skewness	0.46305669
Sum	111781
Variance	2.6278693
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	17048	28.2%
2	12285	20.3%
1	11561	19.1%
4	7748	12.8%
3	7061	11.7%
5	4695	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17048	28.2%
1	11561	19.1%
2	12285	20.3%
3	7061	11.7%
4	7748	12.8%
5	4695	7.8%

Value	Count	Frequency (%)
5	4695	7.8%
4	7748	12.8%
3	7061	11.7%
2	12285	20.3%
1	11561	19.1%
0	17048	28.2%

DimCustomer.EnglishEducation
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Bachelors	18144
Partial College	16623
Graduate Degree	10603
High School	10320
Partial High School	4708

Length

Max length	19
Median length	15
Mean length	12.825888
Min length	9

Characters and Unicode

Total characters	774658
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Graduate Degree
2nd row	High School
3rd row	Bachelors
4th row	Bachelors
5th row	Bachelors

Common Values

Value	Count	Frequency (%)
Bachelors	18144	30.0%
Partial College	16623	27.5%
Graduate Degree	10603	17.6%
High School	10320	17.1%
Partial High School	4708	7.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
partial	21331	19.9%
bachelors	18144	16.9%
college	16623	15.5%
high	15028	14.0%
school	15028	14.0%
graduate	10603	9.9%
degree	10603	9.9%

Most occurring characters

Value	Count	Frequency (%)
e	93802	12.1%
l	87749	11.3%
a	82012	10.6%
o	64823	8.4%
r	60681	7.8%
h	48200	6.2%
	46962	6.1%
g	42254	5.5%
i	36359	4.7%
c	33172	4.3%
Other values (11)	178644	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	774658	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	93802	12.1%
l	87749	11.3%
a	82012	10.6%
o	64823	8.4%
r	60681	7.8%
h	48200	6.2%
	46962	6.1%
g	42254	5.5%
i	36359	4.7%
c	33172	4.3%
Other values (11)	178644	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	774658	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	93802	12.1%
l	87749	11.3%
a	82012	10.6%
o	64823	8.4%
r	60681	7.8%
h	48200	6.2%
	46962	6.1%
g	42254	5.5%
i	36359	4.7%
c	33172	4.3%
Other values (11)	178644	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	774658	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	93802	12.1%
l	87749	11.3%
a	82012	10.6%
o	64823	8.4%
r	60681	7.8%
h	48200	6.2%
	46962	6.1%
g	42254	5.5%
i	36359	4.7%
c	33172	4.3%
Other values (11)	178644	23.1%

DimCustomer.EnglishOccupation
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Professional	18995
Skilled Manual	14261
Management	10594
Clerical	9624
Manual	6924

Length

Max length	14
Median length	12
Mean length	10.796218
Min length	6

Characters and Unicode

Total characters	652070
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Management
2nd row	Professional
3rd row	Skilled Manual
4th row	Professional
5th row	Skilled Manual

Common Values

Value	Count	Frequency (%)
Professional	18995	31.4%
Skilled Manual	14261	23.6%
Management	10594	17.5%
Clerical	9624	15.9%
Manual	6924	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manual	21185	28.4%
professional	18995	25.4%
skilled	14261	19.1%
management	10594	14.2%
clerical	9624	12.9%

Most occurring characters

Value	Count	Frequency (%)
a	92177	14.1%
l	87950	13.5%
e	64068	9.8%
n	61368	9.4%
i	42880	6.6%
o	37990	5.8%
s	37990	5.8%
M	31779	4.9%
r	28619	4.4%
u	21185	3.2%
Other values (11)	146064	22.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	652070	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	92177	14.1%
l	87950	13.5%
e	64068	9.8%
n	61368	9.4%
i	42880	6.6%
o	37990	5.8%
s	37990	5.8%
M	31779	4.9%
r	28619	4.4%
u	21185	3.2%
Other values (11)	146064	22.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	652070	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	92177	14.1%
l	87950	13.5%
e	64068	9.8%
n	61368	9.4%
i	42880	6.6%
o	37990	5.8%
s	37990	5.8%
M	31779	4.9%
r	28619	4.4%
u	21185	3.2%
Other values (11)	146064	22.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	652070	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	92177	14.1%
l	87950	13.5%
e	64068	9.8%
n	61368	9.4%
i	42880	6.6%
o	37990	5.8%
s	37990	5.8%
M	31779	4.9%
r	28619	4.4%
u	21185	3.2%
Other values (11)	146064	22.4%

DimCustomer.HouseOwnerFlag
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

1	41699
0	18699

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

Most occurring characters

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	41699	69.0%
0	18699	31.0%

DimCustomer.NumberCarsOwned
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

2	20522
1	15812
0	14068
3	5688
4	4308

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	60398
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

Most occurring characters

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60398	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	20522	34.0%
1	15812	26.2%
0	14068	23.3%
3	5688	9.4%
4	4308	7.1%

DimCustomer.DateFirstPurchase
Date

Distinct	1124
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Minimum	2010-12-29 00:00:00
Maximum	2014-01-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

DimCustomer.CommuteDistance
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

0-1 Miles	21307
5-10 Miles	10615
1-2 Miles	10170
2-5 Miles	10084
10+ Miles	8222

Length

Max length	10
Median length	9
Mean length	9.1757509
Min length	9

Characters and Unicode

Total characters	554197
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1-2 Miles
2nd row	5-10 Miles
3rd row	2-5 Miles
4th row	2-5 Miles
5th row	2-5 Miles

Common Values

Value	Count	Frequency (%)
0-1 Miles	21307	35.3%
5-10 Miles	10615	17.6%
1-2 Miles	10170	16.8%
2-5 Miles	10084	16.7%
10+ Miles	8222	13.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
miles	60398	50.0%
0-1	21307	17.6%
5-10	10615	8.8%
1-2	10170	8.4%
2-5	10084	8.3%
10	8222	6.8%

Most occurring characters

Value	Count	Frequency (%)
	60398	10.9%
M	60398	10.9%
i	60398	10.9%
l	60398	10.9%
e	60398	10.9%
s	60398	10.9%
-	52176	9.4%
1	50314	9.1%
0	40144	7.2%
5	20699	3.7%
Other values (2)	28476	5.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	554197	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	60398	10.9%
M	60398	10.9%
i	60398	10.9%
l	60398	10.9%
e	60398	10.9%
s	60398	10.9%
-	52176	9.4%
1	50314	9.1%
0	40144	7.2%
5	20699	3.7%
Other values (2)	28476	5.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	554197	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	60398	10.9%
M	60398	10.9%
i	60398	10.9%
l	60398	10.9%
e	60398	10.9%
s	60398	10.9%
-	52176	9.4%
1	50314	9.1%
0	40144	7.2%
5	20699	3.7%
Other values (2)	28476	5.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	554197	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	60398	10.9%
M	60398	10.9%
i	60398	10.9%
l	60398	10.9%
e	60398	10.9%
s	60398	10.9%
-	52176	9.4%
1	50314	9.1%
0	40144	7.2%
5	20699	3.7%
Other values (2)	28476	5.1%

DimProduct.ProductSubcategoryKey
Real number (ℝ)

HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.351469

Minimum	1
Maximum	37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	28
Q3	37
95-th percentile	37
Maximum	37
Range	36
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	13.556081
Coefficient of variation (CV)	0.58052369
Kurtosis	-1.074861
Mean	23.351469
Median Absolute Deviation (MAD)	9
Skewness	-0.68821771
Sum	1410382
Variance	183.76732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
37	17332	28.7%
2	8068	13.4%
28	7981	13.2%
31	6440	10.7%
1	4970	8.2%
21	3332	5.5%
19	2190	3.6%
3	2167	3.6%
30	2121	3.5%
20	1430	2.4%
Other values (7)	4367	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4970	8.2%
2	8068	13.4%
3	2167	3.6%
19	2190	3.6%
20	1430	2.4%
21	3332	5.5%
22	1019	1.7%
23	568	0.9%
25	562	0.9%
26	328	0.5%

Value	Count	Frequency (%)
37	17332	28.7%
32	733	1.2%
31	6440	10.7%
30	2121	3.5%
29	908	1.5%
28	7981	13.2%
27	249	0.4%
26	328	0.5%
25	562	0.9%
23	568	0.9%

DimProduct.EnglishProductName
Text

Distinct	130
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Length

Max length	31
Median length	26
Mean length	19.308835
Min length	12

Characters and Unicode

Total characters	1166215
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Road-650 Black, 62
2nd row	Road-150 Red, 48
3rd row	Road-650 Black, 58
4th row	Road-150 Red, 56
5th row	Road-650 Red, 52

Value	Count	Frequency (%)
tire	14141	7.1%
mountain	11679	5.9%
	8334	4.2%
bottle	7981	4.0%
black	7394	3.7%
tube	6959	3.5%
road	6916	3.5%
sport-100	6440	3.3%
helmet	6440	3.3%
oz	4977	2.5%
Other values (71)	116660	58.9%

Most occurring characters

Value	Count	Frequency (%)
	137523	11.8%
e	97490	8.4%
o	75934	6.5%
t	65916	5.7%
a	62687	5.4%
i	48872	4.2%
n	45744	3.9%
0	44110	3.8%
l	44076	3.8%
r	43494	3.7%
Other values (47)	500369	42.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1166215	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	137523	11.8%
e	97490	8.4%
o	75934	6.5%
t	65916	5.7%
a	62687	5.4%
i	48872	4.2%
n	45744	3.9%
0	44110	3.8%
l	44076	3.8%
r	43494	3.7%
Other values (47)	500369	42.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1166215	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	137523	11.8%
e	97490	8.4%
o	75934	6.5%
t	65916	5.7%
a	62687	5.4%
i	48872	4.2%
n	45744	3.9%
0	44110	3.8%
l	44076	3.8%
r	43494	3.7%
Other values (47)	500369	42.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1166215	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	137523	11.8%
e	97490	8.4%
o	75934	6.5%
t	65916	5.7%
a	62687	5.4%
i	48872	4.2%
n	45744	3.9%
0	44110	3.8%
l	44076	3.8%
r	43494	3.7%
Other values (47)	500369	42.9%

DimProduct.DimProductSubcategory.EnglishProductSubcategoryName
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Tires and Tubes	17332
Road Bikes	8068
Bottles and Cages	7981
Helmets	6440
Mountain Bikes	4970
Other values (12)	15607

Length

Max length	17
Median length	14
Mean length	11.767294
Min length	4

Characters and Unicode

Total characters	710721
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Road Bikes
2nd row	Road Bikes
3rd row	Road Bikes
4th row	Road Bikes
5th row	Road Bikes

Common Values

Value	Count	Frequency (%)
Tires and Tubes	17332	28.7%
Road Bikes	8068	13.4%
Bottles and Cages	7981	13.2%
Helmets	6440	10.7%
Mountain Bikes	4970	8.2%
Jerseys	3332	5.5%
Caps	2190	3.6%
Touring Bikes	2167	3.6%
Fenders	2121	3.5%
Gloves	1430	2.4%
Other values (7)	4367	7.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	25313	19.8%
tires	17332	13.6%
tubes	17332	13.6%
bikes	15205	11.9%
road	8068	6.3%
bottles	7981	6.3%
cages	7981	6.3%
helmets	6440	5.0%
mountain	4970	3.9%
jerseys	3332	2.6%
Other values (13)	13585	10.7%

Most occurring characters

Value	Count	Frequency (%)
e	94002	13.2%
s	89605	12.6%
	67141	9.4%
a	51473	7.2%
n	41431	5.8%
i	40984	5.8%
T	36831	5.2%
d	36484	5.1%
t	29935	4.2%
r	27612	3.9%
Other values (23)	195223	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	710721	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	94002	13.2%
s	89605	12.6%
	67141	9.4%
a	51473	7.2%
n	41431	5.8%
i	40984	5.8%
T	36831	5.2%
d	36484	5.1%
t	29935	4.2%
r	27612	3.9%
Other values (23)	195223	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	710721	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	94002	13.2%
s	89605	12.6%
	67141	9.4%
a	51473	7.2%
n	41431	5.8%
i	40984	5.8%
T	36831	5.2%
d	36484	5.1%
t	29935	4.2%
r	27612	3.9%
Other values (23)	195223	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	710721	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	94002	13.2%
s	89605	12.6%
	67141	9.4%
a	51473	7.2%
n	41431	5.8%
i	40984	5.8%
T	36831	5.2%
d	36484	5.1%
t	29935	4.2%
r	27612	3.9%
Other values (23)	195223	27.5%

DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Accessories	36092
Bikes	15205
Clothing	9101

Length

Max length	11
Median length	11
Mean length	9.0374681
Min length	5

Characters and Unicode

Total characters	545845
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bikes
2nd row	Bikes
3rd row	Bikes
4th row	Bikes
5th row	Bikes

Common Values

Value	Count	Frequency (%)
Accessories	36092	59.8%
Bikes	15205	25.2%
Clothing	9101	15.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
accessories	36092	59.8%
bikes	15205	25.2%
clothing	9101	15.1%

Most occurring characters

Value	Count	Frequency (%)
s	123481	22.6%
e	87389	16.0%
c	72184	13.2%
i	60398	11.1%
o	45193	8.3%
A	36092	6.6%
r	36092	6.6%
B	15205	2.8%
k	15205	2.8%
C	9101	1.7%
Other values (5)	45505	8.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	545845	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	123481	22.6%
e	87389	16.0%
c	72184	13.2%
i	60398	11.1%
o	45193	8.3%
A	36092	6.6%
r	36092	6.6%
B	15205	2.8%
k	15205	2.8%
C	9101	1.7%
Other values (5)	45505	8.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	545845	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	123481	22.6%
e	87389	16.0%
c	72184	13.2%
i	60398	11.1%
o	45193	8.3%
A	36092	6.6%
r	36092	6.6%
B	15205	2.8%
k	15205	2.8%
C	9101	1.7%
Other values (5)	45505	8.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	545845	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	123481	22.6%
e	87389	16.0%
c	72184	13.2%
i	60398	11.1%
o	45193	8.3%
A	36092	6.6%
r	36092	6.6%
B	15205	2.8%
k	15205	2.8%
C	9101	1.7%
Other values (5)	45505	8.3%

DimPromotion.EnglishPromotionName
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

No Discount	58247
Volume Discount 11 to 14	2118
Touring-3000 Promotion	20
Touring-1000 Promotion	13

Length

Max length	24
Median length	11
Mean length	11.461886
Min length	11

Characters and Unicode

Total characters	692275
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Discount
2nd row	No Discount
3rd row	No Discount
4th row	No Discount
5th row	No Discount

Common Values

Value	Count	Frequency (%)
No Discount	58247	96.4%
Volume Discount 11 to 14	2118	3.5%
Touring-3000 Promotion	20	< 0.1%
Touring-1000 Promotion	13	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
discount	60365	47.5%
no	58247	45.8%
volume	2118	1.7%
11	2118	1.7%
to	2118	1.7%
14	2118	1.7%
promotion	33	< 0.1%
touring-3000	20	< 0.1%
touring-1000	13	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	122980	17.8%
	66752	9.6%
u	62516	9.0%
t	62516	9.0%
i	60431	8.7%
n	60431	8.7%
D	60365	8.7%
s	60365	8.7%
c	60365	8.7%
N	58247	8.4%
Other values (13)	17307	2.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	692275	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	122980	17.8%
	66752	9.6%
u	62516	9.0%
t	62516	9.0%
i	60431	8.7%
n	60431	8.7%
D	60365	8.7%
s	60365	8.7%
c	60365	8.7%
N	58247	8.4%
Other values (13)	17307	2.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	692275	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	122980	17.8%
	66752	9.6%
u	62516	9.0%
t	62516	9.0%
i	60431	8.7%
n	60431	8.7%
D	60365	8.7%
s	60365	8.7%
c	60365	8.7%
N	58247	8.4%
Other values (13)	17307	2.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	692275	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	122980	17.8%
	66752	9.6%
u	62516	9.0%
t	62516	9.0%
i	60431	8.7%
n	60431	8.7%
D	60365	8.7%
s	60365	8.7%
c	60365	8.7%
N	58247	8.4%
Other values (13)	17307	2.5%

DimPromotion.EnglishPromotionType
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

No Discount	58247
Volume Discount	2118
New Product	33

Length

Max length	15
Median length	11
Mean length	11.14027
Min length	11

Characters and Unicode

Total characters	672850
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Discount
2nd row	No Discount
3rd row	No Discount
4th row	No Discount
5th row	No Discount

Common Values

Value	Count	Frequency (%)
No Discount	58247	96.4%
Volume Discount	2118	3.5%
New Product	33	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
discount	60365	50.0%
no	58247	48.2%
volume	2118	1.8%
new	33	< 0.1%
product	33	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	120763	17.9%
u	62516	9.3%
t	60398	9.0%
	60398	9.0%
c	60398	9.0%
D	60365	9.0%
i	60365	9.0%
s	60365	9.0%
n	60365	9.0%
N	58280	8.7%
Other values (8)	8637	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	672850	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	120763	17.9%
u	62516	9.3%
t	60398	9.0%
	60398	9.0%
c	60398	9.0%
D	60365	9.0%
i	60365	9.0%
s	60365	9.0%
n	60365	9.0%
N	58280	8.7%
Other values (8)	8637	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	672850	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	120763	17.9%
u	62516	9.3%
t	60398	9.0%
	60398	9.0%
c	60398	9.0%
D	60365	9.0%
i	60365	9.0%
s	60365	9.0%
n	60365	9.0%
N	58280	8.7%
Other values (8)	8637	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	672850	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	120763	17.9%
u	62516	9.3%
t	60398	9.0%
	60398	9.0%
c	60398	9.0%
D	60365	9.0%
i	60365	9.0%
s	60365	9.0%
n	60365	9.0%
N	58280	8.7%
Other values (8)	8637	1.3%

DimPromotion.EnglishPromotionCategory
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

No Discount	58247
Reseller	2151

Length

Max length	11
Median length	11
Mean length	10.893159
Min length	8

Characters and Unicode

Total characters	657925
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Discount
2nd row	No Discount
3rd row	No Discount
4th row	No Discount
5th row	No Discount

Common Values

Value	Count	Frequency (%)
No Discount	58247	96.4%
Reseller	2151	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	58247	49.1%
discount	58247	49.1%
reseller	2151	1.8%

Most occurring characters

Value	Count	Frequency (%)
o	116494	17.7%
s	60398	9.2%
N	58247	8.9%
	58247	8.9%
D	58247	8.9%
i	58247	8.9%
c	58247	8.9%
u	58247	8.9%
n	58247	8.9%
t	58247	8.9%
Other values (4)	15057	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	657925	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	116494	17.7%
s	60398	9.2%
N	58247	8.9%
	58247	8.9%
D	58247	8.9%
i	58247	8.9%
c	58247	8.9%
u	58247	8.9%
n	58247	8.9%
t	58247	8.9%
Other values (4)	15057	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	657925	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	116494	17.7%
s	60398	9.2%
N	58247	8.9%
	58247	8.9%
D	58247	8.9%
i	58247	8.9%
c	58247	8.9%
u	58247	8.9%
n	58247	8.9%
t	58247	8.9%
Other values (4)	15057	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	657925	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	116494	17.7%
s	60398	9.2%
N	58247	8.9%
	58247	8.9%
D	58247	8.9%
i	58247	8.9%
c	58247	8.9%
u	58247	8.9%
n	58247	8.9%
t	58247	8.9%
Other values (4)	15057	2.3%

DimSalesTerritory.SalesTerritoryRegion
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Australia	13345
Southwest	12265
Northwest	8993
Canada	7620
United Kingdom	6906
Other values (5)	11269

Length

Max length	14
Median length	9
Mean length	8.7302229
Min length	6

Characters and Unicode

Total characters	527288
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Southwest
2nd row	Southwest
3rd row	Southwest
4th row	Southwest
5th row	Southwest

Common Values

Value	Count	Frequency (%)
Australia	13345	22.1%
Southwest	12265	20.3%
Northwest	8993	14.9%
Canada	7620	12.6%
United Kingdom	6906	11.4%
Germany	5625	9.3%
France	5558	9.2%
Southeast	39	0.1%
Northeast	27	< 0.1%
Central	20	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
australia	13345	19.8%
southwest	12265	18.2%
northwest	8993	13.4%
canada	7620	11.3%
united	6906	10.3%
kingdom	6906	10.3%
germany	5625	8.4%
france	5558	8.3%
southeast	39	0.1%
northeast	27	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
t	62919	11.9%
a	60819	11.5%
e	39433	7.5%
s	34669	6.6%
r	33568	6.4%
n	32635	6.2%
o	28230	5.4%
i	27157	5.2%
u	25649	4.9%
d	21432	4.1%
Other values (16)	160777	30.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	527288	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	62919	11.9%
a	60819	11.5%
e	39433	7.5%
s	34669	6.6%
r	33568	6.4%
n	32635	6.2%
o	28230	5.4%
i	27157	5.2%
u	25649	4.9%
d	21432	4.1%
Other values (16)	160777	30.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	527288	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	62919	11.9%
a	60819	11.5%
e	39433	7.5%
s	34669	6.6%
r	33568	6.4%
n	32635	6.2%
o	28230	5.4%
i	27157	5.2%
u	25649	4.9%
d	21432	4.1%
Other values (16)	160777	30.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	527288	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	62919	11.9%
a	60819	11.5%
e	39433	7.5%
s	34669	6.6%
r	33568	6.4%
n	32635	6.2%
o	28230	5.4%
i	27157	5.2%
u	25649	4.9%
d	21432	4.1%
Other values (16)	160777	30.5%

DimSalesTerritory.SalesTerritoryCountry
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

United States	21344
Australia	13345
Canada	7620
United Kingdom	6906
Germany	5625

Length

Max length	14
Median length	13
Mean length	10.144442
Min length	6

Characters and Unicode

Total characters	612704
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Common Values

Value	Count	Frequency (%)
United States	21344	35.3%
Australia	13345	22.1%
Canada	7620	12.6%
United Kingdom	6906	11.4%
Germany	5625	9.3%
France	5558	9.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
united	28250	31.9%
states	21344	24.1%
australia	13345	15.1%
canada	7620	8.6%
kingdom	6906	7.8%
germany	5625	6.3%
france	5558	6.3%

Most occurring characters

Value	Count	Frequency (%)
t	84283	13.8%
a	82077	13.4%
e	60777	9.9%
n	53959	8.8%
i	48501	7.9%
d	42776	7.0%
s	34689	5.7%
U	28250	4.6%
	28250	4.6%
r	24528	4.0%
Other values (13)	124614	20.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	612704	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	84283	13.8%
a	82077	13.4%
e	60777	9.9%
n	53959	8.8%
i	48501	7.9%
d	42776	7.0%
s	34689	5.7%
U	28250	4.6%
	28250	4.6%
r	24528	4.0%
Other values (13)	124614	20.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	612704	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	84283	13.8%
a	82077	13.4%
e	60777	9.9%
n	53959	8.8%
i	48501	7.9%
d	42776	7.0%
s	34689	5.7%
U	28250	4.6%
	28250	4.6%
r	24528	4.0%
Other values (13)	124614	20.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	612704	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	84283	13.8%
a	82077	13.4%
e	60777	9.9%
n	53959	8.8%
i	48501	7.9%
d	42776	7.0%
s	34689	5.7%
U	28250	4.6%
	28250	4.6%
r	24528	4.0%
Other values (13)	124614	20.3%

DimSalesTerritory.SalesTerritoryGroup
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

North America	28964
Europe	18089
Pacific	13345

Length

Max length	13
Median length	7
Mean length	9.5778171
Min length	6

Characters and Unicode

Total characters	578481
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	North America
2nd row	North America
3rd row	North America
4th row	North America
5th row	North America

Common Values

Value	Count	Frequency (%)
North America	28964	48.0%
Europe	18089	29.9%
Pacific	13345	22.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
north	28964	32.4%
america	28964	32.4%
europe	18089	20.2%
pacific	13345	14.9%

Most occurring characters

Value	Count	Frequency (%)
r	76017	13.1%
c	55654	9.6%
i	55654	9.6%
e	47053	8.1%
o	47053	8.1%
a	42309	7.3%
m	28964	5.0%
N	28964	5.0%
A	28964	5.0%
	28964	5.0%
Other values (7)	138885	24.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	578481	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	76017	13.1%
c	55654	9.6%
i	55654	9.6%
e	47053	8.1%
o	47053	8.1%
a	42309	7.3%
m	28964	5.0%
N	28964	5.0%
A	28964	5.0%
	28964	5.0%
Other values (7)	138885	24.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	578481	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	76017	13.1%
c	55654	9.6%
i	55654	9.6%
e	47053	8.1%
o	47053	8.1%
a	42309	7.3%
m	28964	5.0%
N	28964	5.0%
A	28964	5.0%
	28964	5.0%
Other values (7)	138885	24.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	578481	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	76017	13.1%
c	55654	9.6%
i	55654	9.6%
e	47053	8.1%
o	47053	8.1%
a	42309	7.3%
m	28964	5.0%
N	28964	5.0%
A	28964	5.0%
	28964	5.0%
Other values (7)	138885	24.0%

Cost
Real number (ℝ)

HIGH CORRELATION

Distinct	45
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	337.10483

Minimum	1.097
Maximum	2547.0126
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	1.097
5-th percentile	1.097
Q1	3.8081
median	14.3653
Q3	351.2787
95-th percentile	1775.3382
Maximum	2547.0126
Range	2545.9156
Interquartile range (IQR)	347.4706

Descriptive statistics

Standard deviation	649.77051
Coefficient of variation (CV)	1.9275028
Kurtosis	2.6559275
Mean	337.10483
Median Absolute Deviation (MAD)	11.975
Skewness	1.9456942
Sum	20360457
Variance	422201.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
2.3903	8827	14.6%
16.7603	6440	10.7%
1.097	3191	5.3%
1.9113	2376	3.9%
4.3063	2280	3.8%
7.8663	2190	3.6%
10.5284	2121	3.5%
4.7853	2025	3.4%
11.9703	1788	3.0%
43.7413	1736	2.9%
Other values (35)	27424	45.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.097	3191	5.3%
1.9113	2376	3.9%
2.3903	8827	14.6%
3.8081	908	1.5%
4.3063	2280	3.8%
4.7853	2025	3.4%
7.8663	2190	3.6%
10.2938	1044	1.7%
10.5284	2121	3.5%
11.7308	1430	2.4%

Value	Count	Frequency (%)
2547.0126	1551	2.6%
2269.1534	185	0.3%
2252.4684	211	0.3%
1811.4997	706	1.2%
1775.3382	439	0.7%
1732.2653	1255	2.1%
1549.7479	758	1.3%
1509.2185	1215	2.0%
1492.9553	1262	2.1%
1335.355	521	0.9%

Profit
Real number (ℝ)

HIGH CORRELATION

Distinct	45
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	148.98208

Minimum	1.1237
Maximum	1130.8366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	1.1237
5-th percentile	1.193
Q1	2.5997
median	13.0197
Q3	139.6414
95-th percentile	810.7715
Maximum	1130.8366
Range	1129.7129
Interquartile range (IQR)	137.0417

Descriptive statistics

Standard deviation	282.06958
Coefficient of variation (CV)	1.8933121
Kurtosis	2.5053805
Mean	148.98208
Median Absolute Deviation (MAD)	10.42
Skewness	1.9515348
Sum	8998219.8
Variance	79563.247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
2.5997	8827	14.6%
18.2297	6440	10.7%
1.193	3191	5.3%
2.0787	2376	3.9%
4.6837	2280	3.8%
1.1237	2190	3.6%
11.4516	2121	3.5%
5.2047	2025	3.4%
13.0197	1788	3.0%
6.2487	1736	2.9%
Other values (35)	27424	45.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.1237	2190	3.6%
1.193	3191	5.3%
2.0787	2376	3.9%
2.5997	8827	14.6%
4.1419	908	1.5%
4.6837	2280	3.8%
5.2047	2025	3.4%
6.2487	1736	2.9%
6.7487	1596	2.6%
11.1962	1044	1.7%

Value	Count	Frequency (%)
1130.8366	185	0.3%
1122.5216	211	0.3%
1031.2574	1551	2.6%
810.7715	1215	2.0%
802.0347	1262	2.1%
736.0646	521	0.9%
728.1328	554	0.9%
668.0118	439	0.7%
651.8047	1255	2.1%
631.8503	706	1.2%

YearlyIncomeRange
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

$50,000 - $79,999	19714
$30,000 - $49,999	16175
$80,000 - $170,000	16029
$10,000 - $29,999	8480

Length

Max length	18
Median length	17
Mean length	17.26539
Min length	17

Characters and Unicode

Total characters	1042795
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	$80,000 - $170,000
2nd row	$50,000 - $79,999
3rd row	$50,000 - $79,999
4th row	$50,000 - $79,999
5th row	$50,000 - $79,999

Common Values

Value	Count	Frequency (%)
$50,000 - $79,999	19714	32.6%
$30,000 - $49,999	16175	26.8%
$80,000 - $170,000	16029	26.5%
$10,000 - $29,999	8480	14.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	60398	33.3%
50,000	19714	10.9%
79,999	19714	10.9%
30,000	16175	8.9%
49,999	16175	8.9%
80,000	16029	8.8%
170,000	16029	8.8%
10,000	8480	4.7%
29,999	8480	4.7%

Most occurring characters

Value	Count	Frequency (%)
0	305708	29.3%
9	177476	17.0%
$	120796	11.6%
,	120796	11.6%
	120796	11.6%
-	60398	5.8%
7	35743	3.4%
1	24509	2.4%
5	19714	1.9%
3	16175	1.6%
Other values (3)	40684	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1042795	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	305708	29.3%
9	177476	17.0%
$	120796	11.6%
,	120796	11.6%
	120796	11.6%
-	60398	5.8%
7	35743	3.4%
1	24509	2.4%
5	19714	1.9%
3	16175	1.6%
Other values (3)	40684	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1042795	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	305708	29.3%
9	177476	17.0%
$	120796	11.6%
,	120796	11.6%
	120796	11.6%
-	60398	5.8%
7	35743	3.4%
1	24509	2.4%
5	19714	1.9%
3	16175	1.6%
Other values (3)	40684	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1042795	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	305708	29.3%
9	177476	17.0%
$	120796	11.6%
,	120796	11.6%
	120796	11.6%
-	60398	5.8%
7	35743	3.4%
1	24509	2.4%
5	19714	1.9%
3	16175	1.6%
Other values (3)	40684	3.9%

Age
Real number (ℝ)

HIGH CORRELATION

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.38435

Minimum	37
Maximum	108
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	472.0 KiB

Quantile statistics

Minimum	37
5-th percentile	39
Q1	45
median	52
Q3	62
95-th percentile	76
Maximum	108
Range	71
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.334976
Coefficient of variation (CV)	0.20842348
Kurtosis	-0.027375664
Mean	54.38435
Median Absolute Deviation (MAD)	8
Skewness	0.70210222
Sum	3284706
Variance	128.48167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49	2319	3.8%
42	2271	3.8%
48	2268	3.8%
44	2230	3.7%
50	2216	3.7%
52	2213	3.7%
45	2181	3.6%
51	2151	3.6%
43	2139	3.5%
47	2091	3.5%
Other values (61)	38319	63.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37	241	0.4%
38	1230	2.0%
39	1636	2.7%
40	1909	3.2%
41	1762	2.9%
42	2271	3.8%
43	2139	3.5%
44	2230	3.7%
45	2181	3.6%
46	1968	3.3%

Value	Count	Frequency (%)
108	3	< 0.1%
107	2	< 0.1%
106	10	< 0.1%
105	9	< 0.1%
103	2	< 0.1%
102	2	< 0.1%
101	4	< 0.1%
100	8	< 0.1%
99	11	< 0.1%
98	8	< 0.1%

Age Range
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	472.0 KiB

Over 45	44799
31-45	15599

Length

Max length	7
Median length	7
Mean length	6.4834597
Min length	5

Characters and Unicode

Total characters	391588
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Over 45
2nd row	31-45
3rd row	Over 45
4th row	Over 45
5th row	Over 45

Common Values

Value	Count	Frequency (%)
Over 45	44799	74.2%
31-45	15599	25.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
over	44799	42.6%
45	44799	42.6%
31-45	15599	14.8%

Most occurring characters

Value	Count	Frequency (%)
4	60398	15.4%
5	60398	15.4%
O	44799	11.4%
v	44799	11.4%
e	44799	11.4%
r	44799	11.4%
	44799	11.4%
3	15599	4.0%
1	15599	4.0%
-	15599	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	391588	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	60398	15.4%
5	60398	15.4%
O	44799	11.4%
v	44799	11.4%
e	44799	11.4%
r	44799	11.4%
	44799	11.4%
3	15599	4.0%
1	15599	4.0%
-	15599	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	391588	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	60398	15.4%
5	60398	15.4%
O	44799	11.4%
v	44799	11.4%
e	44799	11.4%
r	44799	11.4%
	44799	11.4%
3	15599	4.0%
1	15599	4.0%
-	15599	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	391588	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	60398	15.4%
5	60398	15.4%
O	44799	11.4%
v	44799	11.4%
e	44799	11.4%
r	44799	11.4%
	44799	11.4%
3	15599	4.0%
1	15599	4.0%
-	15599	4.0%

Auto

Heatmap
Table

	Age	Age Range	Cost	CurrencyKey	CustomerKey	DimCurrency.CurrencyName	DimCustomer.CommuteDistance	DimCustomer.EnglishEducation	DimCustomer.EnglishOccupation	DimCustomer.Gender	DimCustomer.HouseOwnerFlag	DimCustomer.MaritalStatus	DimCustomer.NumberCarsOwned	DimCustomer.TotalChildren	DimCustomer.YearlyIncome	DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName	DimProduct.DimProductSubcategory.EnglishProductSubcategoryName	DimProduct.ProductSubcategoryKey	DimPromotion.EnglishPromotionCategory	DimPromotion.EnglishPromotionName	DimPromotion.EnglishPromotionType	DimSalesTerritory.SalesTerritoryCountry	DimSalesTerritory.SalesTerritoryGroup	DimSalesTerritory.SalesTerritoryRegion	ExtendedAmount	Freight	ProductKey	ProductStandardCost	Profit	PromotionKey	SalesAmount	SalesOrderLineNumber	SalesTerritoryKey	TaxAmt	TotalProductCost	UnitPrice	YearlyIncomeRange
Age	1.000	0.916	-0.033	0.068	-0.028	0.045	0.192	0.205	0.242	0.027	0.128	0.196	0.193	0.549	0.184	0.055	0.031	0.028	0.007	0.000	0.003	0.059	0.082	0.046	-0.032	-0.032	-0.012	-0.033	-0.028	0.000	-0.032	0.011	-0.072	-0.032	-0.033	-0.032	0.148
Age Range	0.916	1.000	0.003	0.046	-0.015	0.049	0.067	0.103	0.242	0.000	0.120	0.163	0.069	0.452	0.212	0.003	0.025	-0.006	0.000	0.004	0.000	0.049	0.045	0.050	0.003	0.003	-0.016	0.003	0.004	0.004	0.003	0.011	-0.036	0.003	0.003	0.003	0.223
Cost	-0.033	0.003	1.000	-0.054	-0.027	0.125	0.044	0.039	0.062	0.005	0.025	0.044	0.064	-0.052	0.041	0.707	0.480	-0.714	0.187	0.133	0.150	0.079	0.112	0.059	0.998	0.998	-0.173	1.000	0.932	0.133	0.998	-0.386	0.058	0.998	1.000	0.998	0.091
CurrencyKey	0.068	0.046	-0.054	1.000	0.096	1.000	0.134	0.101	0.117	0.011	0.051	0.045	0.108	0.077	-0.100	0.117	0.094	0.049	0.010	0.006	0.009	0.690	0.735	0.690	-0.053	-0.053	0.014	-0.054	-0.050	0.006	-0.053	0.037	-0.651	-0.053	-0.054	-0.053	0.148
CustomerKey	-0.028	-0.015	-0.027	0.096	1.000	0.092	0.052	0.051	0.077	0.023	0.131	0.093	0.044	-0.025	-0.087	0.064	0.123	0.016	0.027	0.026	0.030	0.103	0.098	0.078	-0.029	-0.029	0.068	-0.027	-0.035	0.026	-0.029	-0.009	-0.037	-0.029	-0.027	-0.029	0.094
DimCurrency.CurrencyName	0.045	0.049	0.125	1.000	0.092	1.000	0.168	0.104	0.165	0.013	0.053	0.045	0.134	0.046	-0.183	0.118	0.088	0.032	0.014	0.008	0.011	0.756	0.806	0.756	-0.045	-0.045	0.008	-0.044	-0.045	0.008	-0.045	0.041	-0.137	-0.045	-0.044	-0.045	0.204
DimCustomer.CommuteDistance	0.192	0.067	0.044	0.134	0.052	0.168	1.000	0.167	0.249	0.018	0.240	0.062	0.292	0.071	0.220	0.040	0.039	0.033	0.000	0.001	0.000	0.204	0.282	0.205	-0.023	-0.023	0.000	-0.024	-0.017	0.001	-0.023	-0.009	-0.164	-0.023	-0.024	-0.023	0.225
DimCustomer.EnglishEducation	0.205	0.103	0.039	0.101	0.051	0.104	0.167	1.000	0.265	0.014	0.142	0.097	0.312	-0.006	-0.206	0.047	0.040	0.056	0.000	0.000	0.000	0.135	0.176	0.139	-0.056	-0.056	0.018	-0.057	-0.050	0.000	-0.056	0.005	-0.025	-0.056	-0.057	-0.056	0.256
DimCustomer.EnglishOccupation	0.242	0.242	0.062	0.117	0.077	0.165	0.249	0.265	1.000	0.024	0.132	0.175	0.231	-0.034	0.159	0.025	0.046	0.011	0.007	0.005	0.005	0.293	0.411	0.296	-0.005	-0.005	0.003	-0.006	-0.003	0.005	-0.005	-0.008	-0.225	-0.005	-0.006	-0.005	0.641
DimCustomer.Gender	0.027	0.000	0.005	0.011	0.023	0.013	0.018	0.014	0.024	1.000	0.016	0.051	0.021	0.002	-0.005	0.008	0.002	0.008	0.000	0.000	0.000	0.012	0.000	0.018	-0.009	-0.009	0.004	-0.009	-0.009	0.000	-0.009	-0.000	0.001	-0.009	-0.009	-0.009	0.018
DimCustomer.HouseOwnerFlag	0.128	0.120	0.025	0.051	0.131	0.053	0.240	0.142	0.132	0.016	1.000	0.311	0.160	0.199	0.058	0.000	0.029	-0.007	0.000	0.000	0.000	0.054	0.054	0.058	0.008	0.008	-0.014	0.008	0.010	0.000	0.008	0.005	-0.044	0.008	0.008	0.008	0.082
DimCustomer.MaritalStatus	0.196	0.163	0.044	0.045	0.093	0.045	0.062	0.097	0.175	0.051	0.311	1.000	0.126	-0.174	-0.106	0.042	0.046	-0.037	0.002	0.005	0.002	0.065	0.052	0.067	0.033	0.033	-0.003	0.035	0.029	0.005	0.033	-0.004	0.025	0.033	0.035	0.033	0.116
DimCustomer.NumberCarsOwned	0.193	0.069	0.064	0.108	0.044	0.134	0.292	0.312	0.231	0.021	0.160	0.126	1.000	0.250	0.398	0.063	0.055	0.075	0.000	0.004	0.007	0.157	0.209	0.159	-0.059	-0.059	-0.001	-0.061	-0.051	0.004	-0.059	-0.003	-0.001	-0.059	-0.061	-0.059	0.312
DimCustomer.TotalChildren	0.549	0.452	-0.052	0.077	-0.025	0.046	0.071	-0.006	-0.034	0.002	0.199	-0.174	0.250	1.000	0.241	0.066	0.048	0.055	0.000	0.005	0.002	0.108	0.146	0.111	-0.051	-0.051	-0.003	-0.052	-0.047	0.005	-0.051	0.014	-0.108	-0.051	-0.052	-0.051	0.175
DimCustomer.YearlyIncome	0.184	0.212	0.041	-0.100	-0.087	-0.183	0.220	-0.206	0.159	-0.005	0.058	-0.106	0.398	0.241	1.000	0.025	0.035	-0.034	0.011	0.006	0.008	0.302	0.430	0.230	0.043	0.043	-0.051	0.041	0.046	0.006	0.043	0.013	-0.123	0.043	0.041	0.043	1.000
DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName	0.055	0.003	0.707	0.117	0.064	0.118	0.040	0.047	0.025	0.008	0.000	0.042	0.063	0.066	0.025	1.000	1.000	-0.783	0.114	0.082	0.083	0.103	0.088	0.104	0.585	0.585	-0.208	0.605	0.378	0.082	0.585	-0.182	0.042	0.585	0.605	0.585	0.019
DimProduct.DimProductSubcategory.EnglishProductSubcategoryName	0.031	0.025	0.480	0.094	0.123	0.088	0.039	0.040	0.046	0.002	0.029	0.046	0.055	0.048	0.035	1.000	1.000	0.326	0.190	0.130	0.160	0.084	0.119	0.063	0.065	0.065	0.540	0.061	0.122	0.130	0.065	-0.330	0.013	0.065	0.061	0.065	0.052
DimProduct.ProductSubcategoryKey	0.028	-0.006	-0.714	0.049	0.016	0.032	0.033	0.056	0.011	0.008	-0.007	-0.037	0.075	0.055	-0.034	-0.783	0.326	1.000	0.154	0.090	0.111	0.071	0.096	0.066	-0.706	-0.706	0.310	-0.714	-0.589	0.090	-0.706	0.295	-0.062	-0.706	-0.714	-0.706	0.032
DimPromotion.EnglishPromotionCategory	0.007	0.000	0.187	0.010	0.027	0.014	0.000	0.000	0.007	0.000	0.000	0.002	0.000	0.000	0.011	0.114	0.190	0.154	1.000	1.000	1.000	0.006	0.008	0.004	0.003	0.003	-0.026	0.002	0.012	1.000	0.003	-0.020	0.010	0.003	0.002	0.003	0.007
DimPromotion.EnglishPromotionName	0.000	0.004	0.133	0.006	0.026	0.008	0.001	0.000	0.005	0.000	0.000	0.005	0.004	0.005	0.006	0.082	0.130	0.090	1.000	1.000	1.000	0.007	0.008	0.001	0.003	0.003	-0.026	0.002	0.012	1.000	0.003	-0.019	0.010	0.003	0.002	0.003	0.005
DimPromotion.EnglishPromotionType	0.003	0.000	0.150	0.009	0.030	0.011	0.000	0.000	0.005	0.000	0.000	0.002	0.007	0.002	0.008	0.083	0.160	0.111	1.000	1.000	1.000	0.009	0.008	0.006	-0.004	-0.004	-0.035	-0.005	0.006	1.000	-0.004	-0.014	0.011	-0.004	-0.005	-0.004	0.004
DimSalesTerritory.SalesTerritoryCountry	0.059	0.049	0.079	0.690	0.103	0.756	0.204	0.135	0.293	0.012	0.054	0.065	0.157	0.108	0.302	0.103	0.084	0.071	0.006	0.007	0.009	1.000	1.000	1.000	-0.038	-0.038	0.007	-0.040	-0.033	0.007	-0.038	0.032	-0.681	-0.038	-0.040	-0.038	0.329
DimSalesTerritory.SalesTerritoryGroup	0.082	0.045	0.112	0.735	0.098	0.806	0.282	0.176	0.411	0.000	0.054	0.052	0.209	0.146	0.430	0.088	0.119	0.096	0.008	0.008	0.008	1.000	1.000	1.000	0.049	0.049	-0.007	0.048	0.051	0.008	0.049	-0.040	-0.048	0.049	0.048	0.049	0.400
DimSalesTerritory.SalesTerritoryRegion	0.046	0.050	0.059	0.690	0.078	0.756	0.205	0.139	0.296	0.018	0.058	0.067	0.159	0.111	0.230	0.104	0.063	0.066	0.004	0.001	0.006	1.000	1.000	1.000	-0.032	-0.032	0.005	-0.033	-0.030	0.001	-0.032	0.036	-0.254	-0.032	-0.033	-0.032	0.330
ExtendedAmount	-0.032	0.003	0.998	-0.053	-0.029	-0.045	-0.023	-0.056	-0.005	-0.009	0.008	0.033	-0.059	-0.051	0.043	0.585	0.065	-0.706	0.003	0.003	-0.004	-0.038	0.049	-0.032	1.000	1.000	-0.163	0.998	0.948	0.118	1.000	-0.393	0.054	1.000	0.998	1.000	0.090
Freight	-0.032	0.003	0.998	-0.053	-0.029	-0.045	-0.023	-0.056	-0.005	-0.009	0.008	0.033	-0.059	-0.051	0.043	0.585	0.065	-0.706	0.003	0.003	-0.004	-0.038	0.049	-0.032	1.000	1.000	-0.163	0.998	0.948	0.118	1.000	-0.393	0.054	1.000	0.998	1.000	0.090
ProductKey	-0.012	-0.016	-0.173	0.014	0.068	0.008	0.000	0.018	0.003	0.004	-0.014	-0.003	-0.001	-0.003	-0.051	-0.208	0.540	0.310	-0.026	-0.026	-0.035	0.007	-0.007	0.005	-0.163	-0.163	1.000	-0.173	-0.101	0.132	-0.163	-0.255	-0.012	-0.163	-0.173	-0.163	0.061
ProductStandardCost	-0.033	0.003	1.000	-0.054	-0.027	-0.044	-0.024	-0.057	-0.006	-0.009	0.008	0.035	-0.061	-0.052	0.041	0.605	0.061	-0.714	0.002	0.002	-0.005	-0.040	0.048	-0.033	0.998	0.998	-0.173	1.000	0.932	0.133	0.998	-0.386	0.058	0.998	1.000	0.998	0.091
Profit	-0.028	0.004	0.932	-0.050	-0.035	-0.045	-0.017	-0.050	-0.003	-0.009	0.010	0.029	-0.051	-0.047	0.046	0.378	0.122	-0.589	0.012	0.012	0.006	-0.033	0.051	-0.030	0.948	0.948	-0.101	0.932	1.000	0.122	0.948	-0.433	0.044	0.948	0.932	0.948	0.090
PromotionKey	0.000	0.004	0.133	0.006	0.026	0.008	0.001	0.000	0.005	0.000	0.000	0.005	0.004	0.005	0.006	0.082	0.130	0.090	1.000	1.000	1.000	0.007	0.008	0.001	0.118	0.118	0.132	0.133	0.122	1.000	0.003	-0.020	0.010	0.003	0.002	0.003	0.005
SalesAmount	-0.032	0.003	0.998	-0.053	-0.029	-0.045	-0.023	-0.056	-0.005	-0.009	0.008	0.033	-0.059	-0.051	0.043	0.585	0.065	-0.706	0.003	0.003	-0.004	-0.038	0.049	-0.032	1.000	1.000	-0.163	0.998	0.948	0.003	1.000	-0.393	0.054	1.000	0.998	1.000	0.090
SalesOrderLineNumber	0.011	0.011	-0.386	0.037	-0.009	0.041	-0.009	0.005	-0.008	-0.000	0.005	-0.004	-0.003	0.014	0.013	-0.182	-0.330	0.295	-0.020	-0.019	-0.014	0.032	-0.040	0.036	-0.393	-0.393	-0.255	-0.386	-0.433	-0.020	-0.393	1.000	-0.014	-0.393	-0.386	-0.393	0.012
SalesTerritoryKey	-0.072	-0.036	0.058	-0.651	-0.037	-0.137	-0.164	-0.025	-0.225	0.001	-0.044	0.025	-0.001	-0.108	-0.123	0.042	0.013	-0.062	0.010	0.010	0.011	-0.681	-0.048	-0.254	0.054	0.054	-0.012	0.058	0.044	0.010	0.054	-0.014	1.000	0.054	0.058	0.054	0.330
TaxAmt	-0.032	0.003	0.998	-0.053	-0.029	-0.045	-0.023	-0.056	-0.005	-0.009	0.008	0.033	-0.059	-0.051	0.043	0.585	0.065	-0.706	0.003	0.003	-0.004	-0.038	0.049	-0.032	1.000	1.000	-0.163	0.998	0.948	0.003	1.000	-0.393	0.054	1.000	0.998	1.000	0.090
TotalProductCost	-0.033	0.003	1.000	-0.054	-0.027	-0.044	-0.024	-0.057	-0.006	-0.009	0.008	0.035	-0.061	-0.052	0.041	0.605	0.061	-0.714	0.002	0.002	-0.005	-0.040	0.048	-0.033	0.998	0.998	-0.173	1.000	0.932	0.002	0.998	-0.386	0.058	0.998	1.000	0.998	0.091
UnitPrice	-0.032	0.003	0.998	-0.053	-0.029	-0.045	-0.023	-0.056	-0.005	-0.009	0.008	0.033	-0.059	-0.051	0.043	0.585	0.065	-0.706	0.003	0.003	-0.004	-0.038	0.049	-0.032	1.000	1.000	-0.163	0.998	0.948	0.003	1.000	-0.393	0.054	1.000	0.998	1.000	0.090
YearlyIncomeRange	0.148	0.223	0.091	0.148	0.094	0.204	0.225	0.256	0.641	0.018	0.082	0.116	0.312	0.175	1.000	0.019	0.052	0.032	0.007	0.005	0.004	0.329	0.400	0.330	0.090	0.090	0.061	0.091	0.090	0.005	0.090	0.012	0.330	0.090	0.091	0.090	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ProductKey	CustomerKey	PromotionKey	CurrencyKey	SalesTerritoryKey	SalesOrderNumber	SalesOrderLineNumber	RevisionNumber	OrderQuantity	UnitPrice	ExtendedAmount	ProductStandardCost	TotalProductCost	SalesAmount	TaxAmt	Freight	OrderDate	DueDate	ShipDate	DimCurrency.CurrencyName	CustomerFullName	DimCustomer.BirthDate	DimCustomer.MaritalStatus	DimCustomer.Gender	DimCustomer.YearlyIncome	DimCustomer.TotalChildren	DimCustomer.EnglishEducation	DimCustomer.EnglishOccupation	DimCustomer.HouseOwnerFlag	DimCustomer.NumberCarsOwned	DimCustomer.DateFirstPurchase	DimCustomer.CommuteDistance	DimProduct.ProductSubcategoryKey	DimProduct.EnglishProductName	DimProduct.DimProductSubcategory.EnglishProductSubcategoryName	DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName	DimPromotion.EnglishPromotionName	DimPromotion.EnglishPromotionType	DimPromotion.EnglishPromotionCategory	DimSalesTerritory.SalesTerritoryRegion	DimSalesTerritory.SalesTerritoryCountry	DimSalesTerritory.SalesTerritoryGroup	Cost	Profit	YearlyIncomeRange	Age	Age Range
0	336	14501	1	100	4	SO43700	1	1	1	699.0982	699.0982	413.1463	413.1463	699.0982	55.9279	17.4775	2010-12-29	2011-01-10	2011-01-05	US Dollar	Lucas Hill	1943-11-10	M	M	80000	4	Graduate Degree	Management	1	2	2010-12-29	1-2 Miles	2	Road-650 Black, 62	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	486.5517	212.5465	$80,000 - $170,000	80	Over 45
1	312	27612	1	100	4	SO43719	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-01-03	2011-01-15	2011-01-10	US Dollar	Kelvin Huang	1978-11-18	M	M	60000	2	High School	Professional	1	2	2011-01-03	5-10 Miles	2	Road-150 Red, 48	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$50,000 - $79,999	45	31-45
2	332	14560	1	100	4	SO43726	1	1	1	699.0982	699.0982	413.1463	413.1463	699.0982	55.9279	17.4775	2011-01-05	2011-01-17	2011-01-12	US Dollar	Courtney Carter	1976-03-31	M	M	50000	1	Bachelors	Skilled Manual	1	1	2011-01-05	2-5 Miles	2	Road-650 Black, 58	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	486.5517	212.5465	$50,000 - $79,999	48	Over 45
3	314	27578	1	100	4	SO43762	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-01-14	2011-01-26	2011-01-21	US Dollar	Ashley Washington	1964-05-07	M	F	60000	1	Bachelors	Professional	1	1	2011-01-14	2-5 Miles	2	Road-150 Red, 56	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$50,000 - $79,999	59	Over 45
4	330	14559	1	100	4	SO43771	1	1	1	699.0982	699.0982	413.1463	413.1463	699.0982	55.9279	17.4775	2011-01-16	2011-01-28	2011-01-23	US Dollar	Jeremy Murphy	1976-03-20	M	F	50000	1	Bachelors	Skilled Manual	1	0	2011-01-16	2-5 Miles	2	Road-650 Red, 52	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	486.5517	212.5465	$50,000 - $79,999	48	Over 45
5	312	27651	1	100	4	SO43820	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-01-25	2011-02-06	2011-02-01	US Dollar	Philip Gomez	1961-05-05	M	M	90000	2	High School	Professional	1	1	2011-01-25	10+ Miles	2	Road-150 Red, 48	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$80,000 - $170,000	62	Over 45
6	312	28038	1	100	4	SO43930	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-02-01	2011-02-13	2011-02-08	US Dollar	Melanie Foster	1953-08-19	M	M	70000	2	Partial College	Professional	1	2	2011-02-01	10+ Miles	2	Road-150 Red, 48	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$50,000 - $79,999	70	Over 45
7	336	14572	1	100	4	SO44002	1	1	1	699.0982	699.0982	413.1463	413.1463	699.0982	55.9279	17.4775	2011-02-16	2011-02-28	2011-02-23	US Dollar	Charles Moore	1976-10-13	M	F	70000	3	Graduate Degree	Professional	1	0	2011-02-16	2-5 Miles	2	Road-650 Black, 62	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	486.5517	212.5465	$50,000 - $79,999	47	Over 45
8	310	28172	1	100	4	SO44148	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-03-03	2011-03-15	2011-03-10	US Dollar	Jacqueline Ward	1972-11-23	M	M	60000	1	Partial College	Skilled Manual	1	1	2011-03-03	2-5 Miles	2	Road-150 Red, 62	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$50,000 - $79,999	51	Over 45
9	312	28168	1	100	4	SO44153	1	1	1	3578.2700	3578.2700	2171.2942	2171.2942	3578.2700	286.2616	89.4568	2011-03-04	2011-03-16	2011-03-11	US Dollar	Fernando Turner	1967-04-09	M	F	60000	1	Partial College	Skilled Manual	1	1	2011-03-04	2-5 Miles	2	Road-150 Red, 48	Road Bikes	Bikes	No Discount	No Discount	No Discount	Southwest	United States	North America	2547.0126	1031.2574	$50,000 - $79,999	56	Over 45

	ProductKey	CustomerKey	PromotionKey	CurrencyKey	SalesTerritoryKey	SalesOrderNumber	SalesOrderLineNumber	RevisionNumber	OrderQuantity	UnitPrice	ExtendedAmount	ProductStandardCost	TotalProductCost	SalesAmount	TaxAmt	Freight	OrderDate	DueDate	ShipDate	DimCurrency.CurrencyName	CustomerFullName	DimCustomer.BirthDate	DimCustomer.MaritalStatus	DimCustomer.Gender	DimCustomer.YearlyIncome	DimCustomer.TotalChildren	DimCustomer.EnglishEducation	DimCustomer.EnglishOccupation	DimCustomer.HouseOwnerFlag	DimCustomer.NumberCarsOwned	DimCustomer.DateFirstPurchase	DimCustomer.CommuteDistance	DimProduct.ProductSubcategoryKey	DimProduct.EnglishProductName	DimProduct.DimProductSubcategory.EnglishProductSubcategoryName	DimProduct.DimProductSubcategory.DimProductCategory.EnglishProductCategoryName	DimPromotion.EnglishPromotionName	DimPromotion.EnglishPromotionType	DimPromotion.EnglishPromotionCategory	DimSalesTerritory.SalesTerritoryRegion	DimSalesTerritory.SalesTerritoryCountry	DimSalesTerritory.SalesTerritoryGroup	Cost	Profit	YearlyIncomeRange	Age	Age Range
60388	530	14974	1	98	10	SO73609	2	1	1	4.99	4.99	1.8663	1.8663	4.99	0.3992	0.1248	2013-12-21	2014-01-02	2013-12-28	United Kingdom Pound	K. Saravan	1984-12-29	S	M	30000	3	Partial College	Clerical	1	2	2013-03-31	0-1 Miles	37	Touring Tire Tube	Tires and Tubes	Accessories	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	2.3903	2.5997	$30,000 - $49,999	39	31-45
60389	217	14974	1	98	10	SO73609	3	1	1	34.99	34.99	13.0863	13.0863	34.99	2.7992	0.8748	2013-12-21	2014-01-02	2013-12-28	United Kingdom Pound	K. Saravan	1984-12-29	S	M	30000	3	Partial College	Clerical	1	2	2013-03-31	0-1 Miles	31	Sport-100 Helmet, Black	Helmets	Accessories	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	16.7603	18.2297	$30,000 - $49,999	39	31-45
60390	231	14974	1	98	10	SO73609	4	1	1	49.99	49.99	38.4923	38.4923	49.99	3.9992	1.2498	2013-12-21	2014-01-02	2013-12-28	United Kingdom Pound	Jim Rodman	1984-12-29	S	M	30000	3	Partial College	Clerical	1	2	2013-03-31	0-1 Miles	21	Long-Sleeve Logo Jersey, M	Jerseys	Clothing	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	43.7413	6.2487	$30,000 - $49,999	39	31-45
60391	361	20562	1	98	10	SO73662	1	1	1	2294.99	2294.99	1251.9813	1251.9813	2294.99	183.5992	57.3748	2013-12-22	2014-01-03	2013-12-29	United Kingdom Pound	Andy Ruth	1966-09-09	M	F	130000	3	Partial College	Professional	1	3	2011-08-14	5-10 Miles	1	Mountain-200 Black, 42	Mountain Bikes	Bikes	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	1492.9553	802.0347	$80,000 - $170,000	57	Over 45
60392	529	22706	1	100	8	SO74748	1	1	1	3.99	3.99	1.4923	1.4923	3.99	0.3192	0.0998	2014-01-16	2014-01-28	2014-01-23	US Dollar	Andy Ruth	1981-10-24	S	F	30000	0	Partial College	Clerical	1	1	2014-01-16	2-5 Miles	37	Road Tire Tube	Tires and Tubes	Accessories	No Discount	No Discount	No Discount	Germany	Germany	Europe	1.9113	2.0787	$30,000 - $49,999	42	31-45
60393	225	22706	1	100	8	SO74748	2	1	1	8.99	8.99	6.9223	6.9223	8.99	0.7192	0.2248	2014-01-16	2014-01-28	2014-01-23	US Dollar	Andy Ruth	1981-10-24	S	F	30000	0	Partial College	Clerical	1	1	2014-01-16	2-5 Miles	19	AWC Logo Cap	Caps	Clothing	No Discount	No Discount	No Discount	Germany	Germany	Europe	7.8663	1.1237	$30,000 - $49,999	42	31-45
60394	491	22706	1	100	8	SO74748	3	1	1	53.99	53.99	41.5723	41.5723	53.99	4.3192	1.3498	2014-01-16	2014-01-28	2014-01-23	US Dollar	Timothy Sneath	1981-10-24	S	F	30000	0	Partial College	Clerical	1	1	2014-01-16	2-5 Miles	21	Short-Sleeve Classic Jersey, XL	Jerseys	Clothing	No Discount	No Discount	No Discount	Germany	Germany	Europe	47.2413	6.7487	$30,000 - $49,999	42	31-45
60395	535	17708	1	100	10	SO74828	1	1	1	24.99	24.99	9.3463	9.3463	24.99	1.9992	0.6248	2014-01-19	2014-01-31	2014-01-26	US Dollar	Timothy Sneath	1966-12-15	M	M	20000	1	Graduate Degree	Clerical	1	0	2013-11-13	0-1 Miles	37	LL Mountain Tire	Tires and Tubes	Accessories	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	11.9703	13.0197	$10,000 - $29,999	57	Over 45
60396	477	17708	1	100	10	SO74828	2	1	1	4.99	4.99	1.8663	1.8663	4.99	0.3992	0.1248	2014-01-19	2014-01-31	2014-01-26	US Dollar	Timothy Sneath	1966-12-15	M	M	20000	1	Graduate Degree	Clerical	1	0	2013-11-13	0-1 Miles	28	Water Bottle - 30 oz.	Bottles and Cages	Accessories	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	2.3903	2.5997	$10,000 - $29,999	57	Over 45
60397	471	17708	1	100	10	SO74828	3	1	1	63.50	63.50	23.7490	23.7490	63.50	5.0800	1.5875	2014-01-19	2014-01-31	2014-01-26	US Dollar	NaN	1966-12-15	M	M	20000	1	Graduate Degree	Clerical	1	0	2013-11-13	0-1 Miles	25	Classic Vest, S	Vests	Clothing	No Discount	No Discount	No Discount	United Kingdom	United Kingdom	Europe	30.4165	33.0835	$10,000 - $29,999	57	Over 45

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category